RiverSync
SPEC-ERD-ACC · v0.5
16 June 2026
Owner: Platform team

Account — data model drill-down

The entities behind account.riversync.com: identity and per-app authorization, the organization's structure, the partner surface, and money & history. The widest slice of the model — Account is where most of it is managed.

DraftRenders from the central catalog
Drill-down of the master ERD. Requirements: SPEC-APP-ACC + master SPEC-PRD. Entities and DM-rules render from erd/erd-entities.js — definitions are never copied per document.

1Identity, tenancy & authorization

Identity is grounded in ASP.NET Core Identity 10 (Guid keys): the seven AspNet* tables are the base. ApplicationUser : IdentityUser<Guid>, ApplicationRole : IdentityRole<Guid> and ApplicationUserRole : IdentityUserRole<Guid> subclass the Identity types and carry the RiverSync extension columns; Tenant, Organization, Application, Permission & RolePermission are extension entities with no Identity equivalent. (DM-32, DM-33)

Tenancy + the Identity user side — sources: master TEN-1…3, ID-1…4 · prototype: Sign In.ACC-D1
Roles, app grants & permissions — sources: master AUTH-1…7 · prototypes: Users, Roles, Permissions.ACC-D1b
RiverSync Co., Ltd. · BangkokSPEC-ERD-ACC · 1 of 3

2Organization structure

Sources: ACC-1 · prototypes: Customer Departments (ORGDEPT store), Customer Locations (ORGLOC store).ACC-D2

3Partner surface

Sources: master PRT-1…8 · prototypes: Customer Partners, Customer Partner Detail (Devices · Access · Activity). The same diagram, seen partner-side, lives in the Partners drill-down.ACC-D3
RiverSync Co., Ltd. · BangkokSPEC-ERD-ACC · 2 of 3

4Billing & audit

Sources: ACC-1, ADM-3 · prototypes: Customer Billing, Customer Invoices.ACC-D4
Sources: PRT-4, ADM-5 · prototype: Customer Audit.ACC-D5

5Conditions in play

The DM-rules that bind this app's surfaces — rendered from the central catalog; the master holds the full set.

6Revision history

VersionDateChanges
0.112 Jun 2026First drill-down — split out of SPEC-ERD v0.4; identity/auth, structure, partner surface, billing & audit diagrams
0.213 Jun 2026Identity diagram drops StaffRoleGrant — riversync-tenant roles ride the standard Role / AppRoleGrant model (SPEC-ERD v0.8, SPEC-PRD v0.13)
0.314 Jun 2026Identity re-grounded on ASP.NET Core Identity 10 (SPEC-ERD v0.13) — UserAccount→ApplicationUser «AspNetUsers», IdpIdentity→UserLogin «AspNetUserLogins», Role→ApplicationRole «AspNetRoles», AppRoleGrant→ApplicationUserRole «AspNetUserRoles» (AppKey extension); UserClaim · UserToken · RoleClaim base tables added; the identity figure splits into a tenancy/identity diagram and a new authorization diagram; DM-32 (Identity foundation) and DM-33 (permissions compile to claims) in play
0.415 Jun 2026Structure entity SiteLocation → OrganizationSite (SPEC-ERD v0.16); the structure diagram re-renders from the catalog. Mirrors the Account menu Site Locations → Sites. No model changes.
0.516 Jun 2026Structure entity OrganizationUnit → OrganizationDepartment (SPEC-ERD v0.17); the structure diagram, domain map card and notes re-render from the catalog. Mirrors the Account Departments surface; EntityType still types each node. No model changes.
RiverSync Co., Ltd. · BangkokSPEC-ERD-ACC · 3 of 3